﻿CREATE TABLE [dbo].[WorkEffort]
(
[WorkEffortID] [int] NULL,
[WorkEffortPurposeTypeID] [int] NULL,
[WorkEffortTypeID] [int] NULL,
[AssetID] [int] NULL,
[FixedAssetID] [int] NULL,
[FacilityID] [int] NULL,
[Name] [nvarchar] (50) NULL,
[Description] [nvarchar] (250) NULL,
[ScheduledStartDate] [datetime] NULL,
[ScheduledCompletionDate] [datetime] NULL,
[TotalMoneyAllowed] [money] NULL,
[TotalHoursAllowed] [int] NULL,
[EstimatedHours] [int] NULL,
[SpecialTerms] [nvarchar] (1000) NULL,
[ActualStartDatetime] [datetime] NULL,
[ActualCompletionDatetime] [datetime] NULL,
[ActualHours] [int] NULL
) ON [PRIMARY]


